Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone, can i know what is going on? I am taking over a project from someone else and the data tab is missing and i cant even look into what is the power query code on transform data. My guess is that this report is linked to a database instead of pulling the data in from excel. Any help is appreciated. Thanks!
Solved! Go to Solution.
Hi @Anonymous
Go to File - Options and settings, and follow the figure below to change your settings, then restart Power BI Desktop
Kindly note:
(1) From this picture, we can know that the datasource of your report is Power BI Dataset
and when we use Power BI Desktop to connect Power BI Dataset, the connection mode is Live.
(2) Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
For more information, please read this article, https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the reply. However, i still cant click on the transform tab as shown in the above picture. Any idea how to resolve this issue?
Hi @Anonymous
change this setting:
For more information about Direct Query, you can read this article,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello, thank you for the response. However, i do not have that setting as shown below.
Hi @Anonymous
Go to File - Options and settings, and follow the figure below to change your settings, then restart Power BI Desktop
Kindly note:
(1) From this picture, we can know that the datasource of your report is Power BI Dataset
and when we use Power BI Desktop to connect Power BI Dataset, the connection mode is Live.
(2) Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
For more information, please read this article, https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You cannot see data tab if you import data by using direct query mode.
And click on transform data option in ribbon you will navigate to power query editor.
Hope this will help you!!