Adam is surprisingly understandable at 1.75x speed. Dam you Microsoft for releasing so many features that I need to watch everything at 1.75 x speed to keep up !
Great video! One thing to keep in mind on Fabric transitioning. Some server locations, including major ones like US Central, etc., are currently not supported for Fabric capabilities in the tenant or capacity. MSFT support has stated that those are likely coming onboard by July 2023, but just FYI for those wondering why you can’t access all of the new capabilities even with a premium capacity and the all checkboxes crossed off!
Thank you for the great work as usual. One thing I am struggling to understand is if we will get Copilot even if Fabric is not enabled (I am not the tenant admin). Thanks in advance.
Howdy Guys in Cubes, My biggest question about Fabric is how this is going to impact the Microsoft Certifications for Power BI. Are we going to see certification changes like we did with the DA-300 to the PL-300? Cheers!
The current certifications are still valid. I would imagine that either these data analyst certs get updated or a new cert comes out. I haven't heard any news on that front yet though.
Great video...I love your content. New idea for a video : We are hitting the 25GB limit for the large data model in our Power BI Premium P1 capacity refresh for a couple of big dashboards... Before going from a P1 to a P2 (that provides 50GB of limit per dataset), can you guys prepare a video on possible solutions until corporate can purchase the next capacity. Maybe by splitting the large dataset into 4-5 smaller source/datasets using a dataflow, and then combining them into one dataset, is that possible ? (I read somewhere the top limit was 100GB) - really appreciate it...
Finally git integration for PowerBI. Interested to see how that will work with CICD pipelines across all of Fabric and how workspaces should be structured to support that
But Fabric is in preview state now. So if we starting to use the power bi in out organization, should we start using power bi as a standalone or as part of fabric (considering that fabric is without normal support now (because of preview state)?
You could point out what the future of datamarts is. They are not really needed anymore with lakhouses and warehouses can completely replace them? Thoughts on that? Thanks
Datamarts still have a place. The positioning is thinking more about the citizen dev on the datamart side and then thinking about Synapse Datawarehouse as the pro dev/enterprise spot. We'll get into it more as well.
I am an adminstrator in my Organisation and I have enabled Fabric for the entire Organisation, and it seems like it worked but not totally now when I reload PowerBI I see the Fabric Logo instead of the PowerBI one and the OneLake hub is visible too but I dont see the logo at the bottom left where you can switch the modes, can you please tell me how to fix this. I also have the PowerBI Pro license, and I am located in Germany.
Guys question that I can't seem to find an answer to. With Premium Capacity, when u switch on Fabric do all your existing Workspaces move to One Lake or is that a separate capacity? Many thanks for any clarity.
Short answer is no. OneLake comes in to play when you say to put the data there. For example, with Dataflows Gen2, you can set the output location. You'd need to have a lakehouse created. If you go the traditional import method with Power BI Datasets, those won't reside in OneLake. At least today. I don't know what will happen down the road. I think it would make sense to standardize on that in the long term, but import datasets are still what they were. Same with Dataflows Gen1 and datamarts.
Thanks for the video it's helpful. I got one case though, Is it possible when user with pro license onboarded to the powerbi platform can see all the datasets under selected domain in oneLake Datahub without having the access to workspaces. eg if user selects HR domain all the datasets under that domain are listed where user can see the description of it, if its endorsed or certified that also can be seen and then as per information user raises request to get access to the dataset which flows to the owner of the dataset. Actually trying to give overview of all available datasets to user without having access to it, as per information then user creates request to get access to required dataset, is this something possible in OneLake data hub? Appreciate your response
might be a stupid question, but what if your organisation doesn't enable fabric. what will power bi look like? is there any fabric-specific functionality that relates to power bi specifically that you will not be able to use, not referring to the lakehouse and the personas, all that but any functionality that sits within the power bi service under pro licensing (not premium) . ie git integration / copilot, etc..
The portal, workspaces, and general flow are still there. The things you were familiar with before Fabric. Power BI still works. You just won't be able to take advantage of OneLake and the new workloads.
@Guy in a Cube I'd love to see the following situation explored as I feel like there is opportunity, but I can't determine the effort required vs. benefit: I have a large/complex Power BI Dataset that has been continually improved and made more efficient over several years. When I hear/read things like "Direct Lake" being potentially better than Import Mode, I immediately wonder if I could improve my Dataset even further. What would it take to take that large/complex Power BI Dataset leverage Direct Lake efficiencies?
YES! Already on our radar. I want to take a little more time to understand overall guidance for Direct Lake before going down that path though. In general, I think that could be the case, but what are the limitations and how would that impact the dataset you've created. It may mean that some transformations need to be made further upstream to accomodate. For example, today you can't create calculated columns on Direct Lake. Give us a little time.
Great question. Because the number to parquet files per frabic capacity are limited, I was pondering if our large complex models should get priority for Direct Lake queries. Particular the models that are close to bumping into our current capacity RAM limit.
Hey Adam, thank you for answering that question about Power BI and Fabric, but it raises another question in my mind. Hi always thought that Power BI was part of the Power Platform, but now it sounds like it's part of Fabric. (My head is exploding already!) What is the connection between the Power Platform and Fabric?
My company has some data on Azure SQL that refreshes once every 24 hours. I can write dataflow to bring selected rows into PowerBI. However I want to create some reusable summary tables for which I think Python would be great. Is it possible that in Lakehouse, 1- I create Dataflow that brings data from Azure SQL into a table 2 - Create scheduled pipeline that runs every 24 hours and runs the Dataflow that overwrite my table 3 - Use Pyspark or something similar to create the summary table 4 - Write that table to Lakehouse I am not sure how step 3 and 4 will be automated on schedule? And I am not sure if above is possible at all? Can you please help?
Has anyone encounted an issue with the table containing their measure completely disappearing when loading data from a .pbit file (template) ? I get an error on loading saying: All MEASURES This query does not have any columns with the supported data types. It will be disabled from being loaded to the model. and if i select continue, the report loads without the ALL MEASURES table and all measure in that table are gone ? This has only happened since the june update Does anyone know whats going on and how to resolve it ? PLEASE !!!
If you are taking a "measure's table" aproach try to have there at list one column and one row May be with DAX like this: MeasuresTable = SELECTCOLUMNS( {0}, "ColumnToHide", [Value] )
Off topic... Is there a way to burst and email users applicable data from an enterprise report? i.e. The report contains data for all supervisors direct reports. Each supervisor gets emailed the part of the report with their direct reports. Capability other than each supervisor subscribing and leveraging RLS.
NEVER!!! Why would it be? It's the primary authoring tool. There is not full parity with the web and a lot of folks will still want to use Power BI Desktop. Updates will keep coming.
I hope you're right!! I can see it coming though once there is full parity between desktop and service - it's getting closer. Can't see them wanting to maintain two apps that do basically the same thing. Desktop is a bit frustrating when dealing with large volumes of data in the MS cloud, which is where they obviously want us to go and the service/fabric would really shine. Still... I hope desktop remains!
Adam is surprisingly understandable at 1.75x speed. Dam you Microsoft for releasing so many features that I need to watch everything at 1.75 x speed to keep up !
That's great to know! 😁 I agree there is a lot of info to go through right now.
Thanks for the great content... It's incredibly useful for my day today job.
Great video! One thing to keep in mind on Fabric transitioning. Some server locations, including major ones like US Central, etc., are currently not supported for Fabric capabilities in the tenant or capacity. MSFT support has stated that those are likely coming onboard by July 2023, but just FYI for those wondering why you can’t access all of the new capabilities even with a premium capacity and the all checkboxes crossed off!
Awesome.... very well explained with great clarity while we continue to work with Power BI with new capabilities... Thanks a lot 👏
Awesome job with this video Adam! Thank you.
Thank you for the great work as usual. One thing I am struggling to understand is if we will get Copilot even if Fabric is not enabled (I am not the tenant admin). Thanks in advance.
Thanks! How does it affect customers who are using Power-bi strictly for on-prem data? How can such customers leverage Fabric?
Do you have instructions on how I can connect my information that is in Microsoft Planner to Microsoft Project? Thanks a million!
Howdy Guys in Cubes, My biggest question about Fabric is how this is going to impact the Microsoft Certifications for Power BI. Are we going to see certification changes like we did with the DA-300 to the PL-300? Cheers!
The current certifications are still valid. I would imagine that either these data analyst certs get updated or a new cert comes out. I haven't heard any news on that front yet though.
Great video...I love your content.
New idea for a video : We are hitting the 25GB limit for the large data model in our Power BI Premium P1 capacity refresh for a couple of big dashboards... Before going from a P1 to a P2 (that provides 50GB of limit per dataset), can you guys prepare a video on possible solutions until corporate can purchase the next capacity. Maybe by splitting the large dataset into 4-5 smaller source/datasets using a dataflow, and then combining them into one dataset, is that possible ? (I read somewhere the top limit was 100GB) - really appreciate it...
Finally git integration for PowerBI. Interested to see how that will work with CICD pipelines across all of Fabric and how workspaces should be structured to support that
But Fabric is in preview state now. So if we starting to use the power bi in out organization, should we start using power bi as a standalone or as part of fabric (considering that fabric is without normal support now (because of preview state)?
You could point out what the future of datamarts is. They are not really needed anymore with lakhouses and warehouses can completely replace them? Thoughts on that? Thanks
Agreed, seems like it may sizzle out before ever really starting.
Datamarts still have a place. The positioning is thinking more about the citizen dev on the datamart side and then thinking about Synapse Datawarehouse as the pro dev/enterprise spot. We'll get into it more as well.
I am an adminstrator in my Organisation and I have enabled Fabric for the entire Organisation, and it seems like it worked but not totally now when I reload PowerBI I see the Fabric Logo instead of the PowerBI one and the OneLake hub is visible too but I dont see the logo at the bottom left where you can switch the modes, can you please tell me how to fix this. I also have the PowerBI Pro license, and I am located in Germany.
Guys question that I can't seem to find an answer to.
With Premium Capacity, when u switch on Fabric do all your existing Workspaces move to One Lake or is that a separate capacity? Many thanks for any clarity.
Short answer is no. OneLake comes in to play when you say to put the data there. For example, with Dataflows Gen2, you can set the output location. You'd need to have a lakehouse created. If you go the traditional import method with Power BI Datasets, those won't reside in OneLake. At least today. I don't know what will happen down the road. I think it would make sense to standardize on that in the long term, but import datasets are still what they were. Same with Dataflows Gen1 and datamarts.
If I have some reporting need on an SQL Database, should I look at Microsoft Fabric vs Power BI?
Excited to see it in action once my enterprise brings it online.
I hear ya! Hopefully that will happen soon.
@@GuyInACube I'm in the GCC, so who knows! lol 🤣
Great information
Appreciate that! Thanks for watching 👊
Thanks for the video it's helpful. I got one case though, Is it possible when user with pro license onboarded to the powerbi platform can see all the datasets under selected domain in oneLake Datahub without having the access to workspaces. eg if user selects HR domain all the datasets under that domain are listed where user can see the description of it, if its endorsed or certified that also can be seen and then as per information user raises request to get access to the dataset which flows to the owner of the dataset. Actually trying to give overview of all available datasets to user without having access to it, as per information then user creates request to get access to required dataset, is this something possible in OneLake data hub? Appreciate your response
might be a stupid question, but what if your organisation doesn't enable fabric. what will power bi look like? is there any fabric-specific functionality that relates to power bi specifically that you will not be able to use, not referring to the lakehouse and the personas, all that but any functionality that sits within the power bi service under pro licensing (not premium) . ie git integration / copilot, etc..
The portal, workspaces, and general flow are still there. The things you were familiar with before Fabric. Power BI still works. You just won't be able to take advantage of OneLake and the new workloads.
@Guy in a Cube
I'd love to see the following situation explored as I feel like there is opportunity, but I can't determine the effort required vs. benefit:
I have a large/complex Power BI Dataset that has been continually improved and made more efficient over several years. When I hear/read things like "Direct Lake" being potentially better than Import Mode, I immediately wonder if I could improve my Dataset even further.
What would it take to take that large/complex Power BI Dataset leverage Direct Lake efficiencies?
YES! Already on our radar. I want to take a little more time to understand overall guidance for Direct Lake before going down that path though. In general, I think that could be the case, but what are the limitations and how would that impact the dataset you've created. It may mean that some transformations need to be made further upstream to accomodate. For example, today you can't create calculated columns on Direct Lake. Give us a little time.
@@GuyInACube Thank you, looking forwarding to it. Great content so far.
Great question. Because the number to parquet files per frabic capacity are limited, I was pondering if our large complex models should get priority for Direct Lake queries. Particular the models that are close to bumping into our current capacity RAM limit.
Hey Adam, thank you for answering that question about Power BI and Fabric, but it raises another question in my mind. Hi always thought that Power BI was part of the Power Platform, but now it sounds like it's part of Fabric. (My head is exploding already!) What is the connection between the Power Platform and Fabric?
Love it
Hi! Could I use a different BI tool with Microsoft Fabric?
Yes. IBM Cognos is very modern and capable
My company has some data on Azure SQL that refreshes once every 24 hours.
I can write dataflow to bring selected rows into PowerBI.
However I want to create some reusable summary tables for which I think Python would be great.
Is it possible that in Lakehouse,
1- I create Dataflow that brings data from Azure SQL into a table
2 - Create scheduled pipeline that runs every 24 hours and runs the Dataflow that overwrite my table
3 - Use Pyspark or something similar to create the summary table
4 - Write that table to Lakehouse
I am not sure how step 3 and 4 will be automated on schedule? And I am not sure if above is possible at all?
Can you please help?
Has anyone encounted an issue with the table containing their measure completely disappearing when loading data from a .pbit file (template) ?
I get an error on loading saying: All MEASURES This query does not have any columns with the supported data types. It will be disabled from being loaded to the model. and if i select continue, the report loads without the ALL MEASURES table and all measure in that table are gone ?
This has only happened since the june update
Does anyone know whats going on and how to resolve it ?
PLEASE !!!
I haven't heard of that. May be worth opening a support ticket.
If you are taking a "measure's table" aproach try to have there at list one column and one row
May be with DAX like this:
MeasuresTable = SELECTCOLUMNS( {0}, "ColumnToHide", [Value] )
Off topic... Is there a way to burst and email users applicable data from an enterprise report? i.e. The report contains data for all supervisors direct reports. Each supervisor gets emailed the part of the report with their direct reports. Capability other than each supervisor subscribing and leveraging RLS.
It is planned for Sep 2023 release.
I hope in one day they will do export button. For clear all it takes 3 year :)
What do you mean by export button?
Sounds promising
I agree 👊
When do you think Power BI Desktop will be retired?
NEVER!!! Why would it be? It's the primary authoring tool. There is not full parity with the web and a lot of folks will still want to use Power BI Desktop. Updates will keep coming.
I hope you're right!! I can see it coming though once there is full parity between desktop and service - it's getting closer. Can't see them wanting to maintain two apps that do basically the same thing. Desktop is a bit frustrating when dealing with large volumes of data in the MS cloud, which is where they obviously want us to go and the service/fabric would really shine. Still... I hope desktop remains!