Forum Discussion
Can't refresh a report
Hi guys, I've got a problem which occurrs when i try to set up scheduled refresh to report published on my organization's powerbi app. The main problem is that even if i try to just make a manual...
Hi JKrason ,
From my notes when I did this for the service.
Power BI open a SharePoint file
- Go to the file and open it as an excel file
- Go to info and copy the path
- Paste to Notes delete everything after the .xlsx in the path
- Copy the remainder to Power Query by using new source and using the Web connector
Found this at How to Connect to a Specific file from SharePoint to Power BI - EnjoySharePoint
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
I published a single pbix with just a sharepoint excel connected and it works. The error in main file says it's a problem with one of the cube's. I have another report made out of those 2 cubes and it works fine as well, everything seems to be almost the same, but this file recieve an error while you try to refresh it.