Forum Discussion
No transformations possible when using a existing dataset as source?
Hi, DeBIe ;
According to the official document. about live connection's limit.
- 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).
1.Since the functionality is currently in preview, you must first enable it. To do so, in Power BI Desktop go to File > Options and settings > Options, and in the Preview features section, select the DirectQuery for Power BI datasets and Analysis Services
2.You can click make changes to this mode on the icon in the lower right corner of PowerBI.
3.Now you can import other data sources
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Chris11Cox
We've setup our data-structure differently because of the limitations. We use a staging database and datawarehouse. I remember that you can have 'some' edit rights but you will have to be in direct query mode. I remember it was very limited. Doing this in import mode is not possible, since you are not saving the dataset to your PBI model, but it's more like a ready only connection. So the data must be perfect without the need to do any transformations in the query editor. Was way to limited for me so unfortunately.
Thanks for the update.
I'm in a position where I have limited choice due to the nature of the company and how their data is stored.
In this particular instance, the date (xlsx file) is located in a SharePoint (online) site within a folder structure.
I can't sync this local via ODfB as its not permitted, so I need to use the data from SharePoint directly, hence why it's in my Workspace in app.powerbi.com
I guess the only way is to have a local copy of the xlsx file that will have to be manually updated when they make changes to the online version?
Thanks again for your help.
Have you connected to the xlsx file via Web-connection within PowerBI? I don't understand why you are not permitted to use the data from SharePoint directly. Your credentials should have access. Maintaining a local file locally sounds like trouble to me.
Thanks DeBle .... thats done the trick.
I've tried the SharePoint connections and thats where issues were, moving to the Web connection and pointing right to the file path has worked, I can now use Power Query from within PowerBI to do what I need to.
Thanks again